﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using OsPortal;
using System.Data.SqlClient;

/// <summary>
/// Summary description for clsLogGold
/// </summary>
public class clsLogGold
{
    static string strClassName = "clsLogGold";
    public clsLogGold()
    {
        //
        // TODO: Add constructor logic here
        //
    }

    /// <summary>
    /// Get Log Gold
    /// </summary>
    /// <param name="iCurrPage"></param>
    /// <param name="iPageSize"></param>
    /// <param name="iNG_ID"></param>
    /// <param name="strUS_ID"></param>
    /// <returns></returns>
    public static DataSet LOGGOLD_FND(int iCurrPage
                                        , int iPageSize
                                        , int iNG_ID
                                        , string strUS_ID)
    {
        DataSet dtData = null;
        try
        {
            dtData = oSqlDataHelper.sExecuteDataSet("LOGGOLD_FND", new SqlParameter[]{
                new SqlParameter("@P_CURRPAGE",iCurrPage)
                ,new SqlParameter("@P_PAGESIZE",iPageSize)
                ,new SqlParameter("@P_NG_ID",iNG_ID)
                ,new SqlParameter("@P_US_ID",strUS_ID)
            });
            return dtData;
        }
        catch (Exception ex)
        {
            OsPortal.oFileHelper.WriteLogErr(strClassName, "LOGGOLD_FND", ex.ToString());
            return null;
        }
        finally
        {
            //dtData.Dispose();
        }
    }


}